package com.os.toytrade.domain.toy;

import com.jc.base.page.Page;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ToyAberdeenInfoConditions {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Page page;

    private Date shardDate;

    public ToyAberdeenInfoConditions() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPage(Page page) {
        this.page = page;
    }

    public Page getPage() {
        return this.page;
    }

    public void setShardDate(Date shardDate) {
        this.shardDate = shardDate;
    }

    public Date getShardDate() {
        return this.shardDate;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberIsNull() {
            addCriterion("aberdeen_number is null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberIsNotNull() {
            addCriterion("aberdeen_number is not null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberEqualTo(String value) {
            addCriterion("aberdeen_number =", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberNotEqualTo(String value) {
            addCriterion("aberdeen_number <>", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberGreaterThan(String value) {
            addCriterion("aberdeen_number >", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberGreaterThanOrEqualTo(String value) {
            addCriterion("aberdeen_number >=", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberLessThan(String value) {
            addCriterion("aberdeen_number <", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberLessThanOrEqualTo(String value) {
            addCriterion("aberdeen_number <=", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberLike(String value) {
            addCriterion("aberdeen_number like", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberNotLike(String value) {
            addCriterion("aberdeen_number not like", value, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberIn(List<String> values) {
            addCriterion("aberdeen_number in", values, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberNotIn(List<String> values) {
            addCriterion("aberdeen_number not in", values, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberBetween(String value1, String value2) {
            addCriterion("aberdeen_number between", value1, value2, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberNotBetween(String value1, String value2) {
            addCriterion("aberdeen_number not between", value1, value2, "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChIsNull() {
            addCriterion("aberdeen_name_ch is null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChIsNotNull() {
            addCriterion("aberdeen_name_ch is not null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChEqualTo(String value) {
            addCriterion("aberdeen_name_ch =", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChNotEqualTo(String value) {
            addCriterion("aberdeen_name_ch <>", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChGreaterThan(String value) {
            addCriterion("aberdeen_name_ch >", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChGreaterThanOrEqualTo(String value) {
            addCriterion("aberdeen_name_ch >=", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChLessThan(String value) {
            addCriterion("aberdeen_name_ch <", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChLessThanOrEqualTo(String value) {
            addCriterion("aberdeen_name_ch <=", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChLike(String value) {
            addCriterion("aberdeen_name_ch like", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChNotLike(String value) {
            addCriterion("aberdeen_name_ch not like", value, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChIn(List<String> values) {
            addCriterion("aberdeen_name_ch in", values, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChNotIn(List<String> values) {
            addCriterion("aberdeen_name_ch not in", values, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChBetween(String value1, String value2) {
            addCriterion("aberdeen_name_ch between", value1, value2, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChNotBetween(String value1, String value2) {
            addCriterion("aberdeen_name_ch not between", value1, value2, "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnIsNull() {
            addCriterion("aberdeen_name_en is null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnIsNotNull() {
            addCriterion("aberdeen_name_en is not null");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnEqualTo(String value) {
            addCriterion("aberdeen_name_en =", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnNotEqualTo(String value) {
            addCriterion("aberdeen_name_en <>", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnGreaterThan(String value) {
            addCriterion("aberdeen_name_en >", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnGreaterThanOrEqualTo(String value) {
            addCriterion("aberdeen_name_en >=", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnLessThan(String value) {
            addCriterion("aberdeen_name_en <", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnLessThanOrEqualTo(String value) {
            addCriterion("aberdeen_name_en <=", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnLike(String value) {
            addCriterion("aberdeen_name_en like", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnNotLike(String value) {
            addCriterion("aberdeen_name_en not like", value, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnIn(List<String> values) {
            addCriterion("aberdeen_name_en in", values, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnNotIn(List<String> values) {
            addCriterion("aberdeen_name_en not in", values, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnBetween(String value1, String value2) {
            addCriterion("aberdeen_name_en between", value1, value2, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnNotBetween(String value1, String value2) {
            addCriterion("aberdeen_name_en not between", value1, value2, "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andCharacterNameIsNull() {
            addCriterion("character_name is null");
            return (Criteria) this;
        }

        public Criteria andCharacterNameIsNotNull() {
            addCriterion("character_name is not null");
            return (Criteria) this;
        }

        public Criteria andCharacterNameEqualTo(String value) {
            addCriterion("character_name =", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameNotEqualTo(String value) {
            addCriterion("character_name <>", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameGreaterThan(String value) {
            addCriterion("character_name >", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameGreaterThanOrEqualTo(String value) {
            addCriterion("character_name >=", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameLessThan(String value) {
            addCriterion("character_name <", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameLessThanOrEqualTo(String value) {
            addCriterion("character_name <=", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameLike(String value) {
            addCriterion("character_name like", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameNotLike(String value) {
            addCriterion("character_name not like", value, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameIn(List<String> values) {
            addCriterion("character_name in", values, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameNotIn(List<String> values) {
            addCriterion("character_name not in", values, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameBetween(String value1, String value2) {
            addCriterion("character_name between", value1, value2, "characterName");
            return (Criteria) this;
        }

        public Criteria andCharacterNameNotBetween(String value1, String value2) {
            addCriterion("character_name not between", value1, value2, "characterName");
            return (Criteria) this;
        }

        public Criteria andCategoryId1IsNull() {
            addCriterion("category_id_1 is null");
            return (Criteria) this;
        }

        public Criteria andCategoryId1IsNotNull() {
            addCriterion("category_id_1 is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryId1EqualTo(String value) {
            addCriterion("category_id_1 =", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1NotEqualTo(String value) {
            addCriterion("category_id_1 <>", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1GreaterThan(String value) {
            addCriterion("category_id_1 >", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1GreaterThanOrEqualTo(String value) {
            addCriterion("category_id_1 >=", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1LessThan(String value) {
            addCriterion("category_id_1 <", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1LessThanOrEqualTo(String value) {
            addCriterion("category_id_1 <=", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1Like(String value) {
            addCriterion("category_id_1 like", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1NotLike(String value) {
            addCriterion("category_id_1 not like", value, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1In(List<String> values) {
            addCriterion("category_id_1 in", values, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1NotIn(List<String> values) {
            addCriterion("category_id_1 not in", values, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1Between(String value1, String value2) {
            addCriterion("category_id_1 between", value1, value2, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId1NotBetween(String value1, String value2) {
            addCriterion("category_id_1 not between", value1, value2, "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId2IsNull() {
            addCriterion("category_id_2 is null");
            return (Criteria) this;
        }

        public Criteria andCategoryId2IsNotNull() {
            addCriterion("category_id_2 is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryId2EqualTo(String value) {
            addCriterion("category_id_2 =", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2NotEqualTo(String value) {
            addCriterion("category_id_2 <>", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2GreaterThan(String value) {
            addCriterion("category_id_2 >", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2GreaterThanOrEqualTo(String value) {
            addCriterion("category_id_2 >=", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2LessThan(String value) {
            addCriterion("category_id_2 <", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2LessThanOrEqualTo(String value) {
            addCriterion("category_id_2 <=", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2Like(String value) {
            addCriterion("category_id_2 like", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2NotLike(String value) {
            addCriterion("category_id_2 not like", value, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2In(List<String> values) {
            addCriterion("category_id_2 in", values, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2NotIn(List<String> values) {
            addCriterion("category_id_2 not in", values, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2Between(String value1, String value2) {
            addCriterion("category_id_2 between", value1, value2, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andCategoryId2NotBetween(String value1, String value2) {
            addCriterion("category_id_2 not between", value1, value2, "categoryId2");
            return (Criteria) this;
        }

        public Criteria andReleasedIsNull() {
            addCriterion("released is null");
            return (Criteria) this;
        }

        public Criteria andReleasedIsNotNull() {
            addCriterion("released is not null");
            return (Criteria) this;
        }

        public Criteria andReleasedEqualTo(Integer value) {
            addCriterion("released =", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedNotEqualTo(Integer value) {
            addCriterion("released <>", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedGreaterThan(Integer value) {
            addCriterion("released >", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedGreaterThanOrEqualTo(Integer value) {
            addCriterion("released >=", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedLessThan(Integer value) {
            addCriterion("released <", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedLessThanOrEqualTo(Integer value) {
            addCriterion("released <=", value, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedIn(List<Integer> values) {
            addCriterion("released in", values, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedNotIn(List<Integer> values) {
            addCriterion("released not in", values, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedBetween(Integer value1, Integer value2) {
            addCriterion("released between", value1, value2, "released");
            return (Criteria) this;
        }

        public Criteria andReleasedNotBetween(Integer value1, Integer value2) {
            addCriterion("released not between", value1, value2, "released");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeIsNull() {
            addCriterion("taxonomy_code is null");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeIsNotNull() {
            addCriterion("taxonomy_code is not null");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeEqualTo(String value) {
            addCriterion("taxonomy_code =", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeNotEqualTo(String value) {
            addCriterion("taxonomy_code <>", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeGreaterThan(String value) {
            addCriterion("taxonomy_code >", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("taxonomy_code >=", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeLessThan(String value) {
            addCriterion("taxonomy_code <", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeLessThanOrEqualTo(String value) {
            addCriterion("taxonomy_code <=", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeLike(String value) {
            addCriterion("taxonomy_code like", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeNotLike(String value) {
            addCriterion("taxonomy_code not like", value, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeIn(List<String> values) {
            addCriterion("taxonomy_code in", values, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeNotIn(List<String> values) {
            addCriterion("taxonomy_code not in", values, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeBetween(String value1, String value2) {
            addCriterion("taxonomy_code between", value1, value2, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeNotBetween(String value1, String value2) {
            addCriterion("taxonomy_code not between", value1, value2, "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIsNull() {
            addCriterion("created_at is null");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIsNotNull() {
            addCriterion("created_at is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedAtEqualTo(Date value) {
            addCriterion("created_at =", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotEqualTo(Date value) {
            addCriterion("created_at <>", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThan(Date value) {
            addCriterion("created_at >", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThanOrEqualTo(Date value) {
            addCriterion("created_at >=", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThan(Date value) {
            addCriterion("created_at <", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThanOrEqualTo(Date value) {
            addCriterion("created_at <=", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIn(List<Date> values) {
            addCriterion("created_at in", values, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotIn(List<Date> values) {
            addCriterion("created_at not in", values, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtBetween(Date value1, Date value2) {
            addCriterion("created_at between", value1, value2, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotBetween(Date value1, Date value2) {
            addCriterion("created_at not between", value1, value2, "createdAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIsNull() {
            addCriterion("updated_at is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIsNotNull() {
            addCriterion("updated_at is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtEqualTo(Date value) {
            addCriterion("updated_at =", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotEqualTo(Date value) {
            addCriterion("updated_at <>", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThan(Date value) {
            addCriterion("updated_at >", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThanOrEqualTo(Date value) {
            addCriterion("updated_at >=", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThan(Date value) {
            addCriterion("updated_at <", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThanOrEqualTo(Date value) {
            addCriterion("updated_at <=", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIn(List<Date> values) {
            addCriterion("updated_at in", values, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotIn(List<Date> values) {
            addCriterion("updated_at not in", values, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtBetween(Date value1, Date value2) {
            addCriterion("updated_at between", value1, value2, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotBetween(Date value1, Date value2) {
            addCriterion("updated_at not between", value1, value2, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andIdLikeInsensitive(String value) {
            addCriterion("upper(id) like", value.toUpperCase(), "id");
            return (Criteria) this;
        }

        public Criteria andAberdeenNumberLikeInsensitive(String value) {
            addCriterion("upper(aberdeen_number) like", value.toUpperCase(), "aberdeenNumber");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameChLikeInsensitive(String value) {
            addCriterion("upper(aberdeen_name_ch) like", value.toUpperCase(), "aberdeenNameCh");
            return (Criteria) this;
        }

        public Criteria andAberdeenNameEnLikeInsensitive(String value) {
            addCriterion("upper(aberdeen_name_en) like", value.toUpperCase(), "aberdeenNameEn");
            return (Criteria) this;
        }

        public Criteria andCharacterNameLikeInsensitive(String value) {
            addCriterion("upper(character_name) like", value.toUpperCase(), "characterName");
            return (Criteria) this;
        }

        public Criteria andCategoryId1LikeInsensitive(String value) {
            addCriterion("upper(category_id_1) like", value.toUpperCase(), "categoryId1");
            return (Criteria) this;
        }

        public Criteria andCategoryId2LikeInsensitive(String value) {
            addCriterion("upper(category_id_2) like", value.toUpperCase(), "categoryId2");
            return (Criteria) this;
        }

        public Criteria andTaxonomyCodeLikeInsensitive(String value) {
            addCriterion("upper(taxonomy_code) like", value.toUpperCase(), "taxonomyCode");
            return (Criteria) this;
        }

        public Criteria andRemarksLikeInsensitive(String value) {
            addCriterion("upper(remarks) like", value.toUpperCase(), "remarks");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}